Re: Need help with currval and nextvall... - Mailing list pgsql-novice

From Dan Jewett
Subject Re: Need help with currval and nextvall...
Date
Msg-id p05200f0bba04345c3c3c@[162.84.132.56]
Whole thread Raw
In response to Re: Need help with currval and nextvall...  (Philip Hallstrom <philip@adhesivemedia.com>)
Responses Re: Need help with currval and nextvall...  (Philip Hallstrom <philip@adhesivemedia.com>)
Re: Need help with currval and nextvall...  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
>You need to quote (single quotes) the name of the sequence... and you need
>to use nextval('album_album_id_seq') before calling currval().
>
>At least I think so.

Thanks Phillip,

I know I'm supposed to have the quotes but I keep getting :
PostgreSQL said: ERROR: parser: parse error at or near
"album_album_id_seq"  unless I take them out.

I also tried nextval() with the same error returned: ERROR: Attribute
'album_album_id_seq' not found.

Dunnoh,

Dan

pgsql-novice by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: Need help with currval and nextvall...
Next
From: Philip Hallstrom
Date:
Subject: Re: Need help with currval and nextvall...